﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="SGTDdsReporte1" targetNamespace="http://tempuri.org/SGTDdsReporte1.xsd" xmlns:mstns="http://tempuri.org/SGTDdsReporte1.xsd" xmlns="http://tempuri.org/SGTDdsReporte1.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="conexion" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="conexion (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.SGTD.Properties.Settings.GlobalReference.Default.conexion" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AreaTableAdapter" GeneratorDataComponentClassName="AreaTableAdapter" Name="Area" UserDataComponentName="AreaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="conexion (Settings)" DbObjectName="SGTD.dbo.Area" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Area] WHERE (([IdArea] = @Original_IdArea))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdArea" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdArea" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Area] ([NombreArea], [IdJefe], [Estado]) VALUES (@NombreArea, @IdJefe, @Estado)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NombreArea" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NombreArea" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdJefe" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdJefe" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Estado" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Estado" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IdArea, NombreArea, IdJefe, Estado FROM dbo.Area</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Area] SET [NombreArea] = @NombreArea, [IdJefe] = @IdJefe, [Estado] = @Estado WHERE (([IdArea] = @Original_IdArea))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NombreArea" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NombreArea" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdJefe" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdJefe" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Estado" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Estado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdArea" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdArea" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdArea" DataSetColumn="IdArea" />
              <Mapping SourceColumn="NombreArea" DataSetColumn="NombreArea" />
              <Mapping SourceColumn="IdJefe" DataSetColumn="IdJefe" />
              <Mapping SourceColumn="Estado" DataSetColumn="Estado" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CorreoTableAdapter" GeneratorDataComponentClassName="CorreoTableAdapter" Name="Correo" UserDataComponentName="CorreoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="conexion (Settings)" DbObjectName="SGTD.dbo.Correo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Correo] WHERE (([IdCorreo] = @Original_IdCorreo))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdCorreo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdCorreo" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Correo] ([Mensaje], [Asunto], [Destinatario], [Emisor], [Estado], [IdFichaTramiteDocumento]) VALUES (@Mensaje, @Asunto, @Destinatario, @Emisor, @Estado, @IdFichaTramiteDocumento)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Mensaje" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Mensaje" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Asunto" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Asunto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Destinatario" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Destinatario" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Emisor" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Emisor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Estado" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Estado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdFichaTramiteDocumento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdFichaTramiteDocumento" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IdCorreo, Mensaje, Asunto, Destinatario, Emisor, Estado, IdFichaTramiteDocumento FROM dbo.Correo</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Correo] SET [Mensaje] = @Mensaje, [Asunto] = @Asunto, [Destinatario] = @Destinatario, [Emisor] = @Emisor, [Estado] = @Estado, [IdFichaTramiteDocumento] = @IdFichaTramiteDocumento WHERE (([IdCorreo] = @Original_IdCorreo))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Mensaje" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Mensaje" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Asunto" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Asunto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Destinatario" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Destinatario" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Emisor" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Emisor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Estado" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Estado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdFichaTramiteDocumento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdFichaTramiteDocumento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdCorreo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdCorreo" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdCorreo" DataSetColumn="IdCorreo" />
              <Mapping SourceColumn="Mensaje" DataSetColumn="Mensaje" />
              <Mapping SourceColumn="Asunto" DataSetColumn="Asunto" />
              <Mapping SourceColumn="Destinatario" DataSetColumn="Destinatario" />
              <Mapping SourceColumn="Emisor" DataSetColumn="Emisor" />
              <Mapping SourceColumn="Estado" DataSetColumn="Estado" />
              <Mapping SourceColumn="IdFichaTramiteDocumento" DataSetColumn="IdFichaTramiteDocumento" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DocumentoTableAdapter" GeneratorDataComponentClassName="DocumentoTableAdapter" Name="Documento" UserDataComponentName="DocumentoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="conexion (Settings)" DbObjectName="SGTD.dbo.Documento" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Documento] WHERE (([IdDocumento] = @Original_IdDocumento))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdDocumento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdDocumento" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Documento] ([NroDocumento], [Nombre], [IdTipoDocumento], [IdTipoFichaTramite], [Estado]) VALUES (@NroDocumento, @Nombre, @IdTipoDocumento, @IdTipoFichaTramite, @Estado)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NroDocumento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NroDocumento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nombre" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdTipoDocumento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdTipoDocumento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdTipoFichaTramite" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdTipoFichaTramite" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Estado" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Estado" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IdDocumento, NroDocumento, Nombre, IdTipoDocumento, IdTipoFichaTramite, Estado FROM dbo.Documento</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Documento] SET [NroDocumento] = @NroDocumento, [Nombre] = @Nombre, [IdTipoDocumento] = @IdTipoDocumento, [IdTipoFichaTramite] = @IdTipoFichaTramite, [Estado] = @Estado WHERE (([IdDocumento] = @Original_IdDocumento))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NroDocumento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NroDocumento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nombre" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdTipoDocumento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdTipoDocumento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdTipoFichaTramite" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdTipoFichaTramite" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Estado" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Estado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdDocumento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdDocumento" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdDocumento" DataSetColumn="IdDocumento" />
              <Mapping SourceColumn="NroDocumento" DataSetColumn="NroDocumento" />
              <Mapping SourceColumn="Nombre" DataSetColumn="Nombre" />
              <Mapping SourceColumn="IdTipoDocumento" DataSetColumn="IdTipoDocumento" />
              <Mapping SourceColumn="IdTipoFichaTramite" DataSetColumn="IdTipoFichaTramite" />
              <Mapping SourceColumn="Estado" DataSetColumn="Estado" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FichaTramiteTableAdapter" GeneratorDataComponentClassName="FichaTramiteTableAdapter" Name="FichaTramite" UserDataComponentName="FichaTramiteTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="conexion (Settings)" DbObjectName="SGTD.dbo.FichaTramite" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[FichaTramite] WHERE (([IdFichaTramite] = @Original_IdFichaTramite))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdFichaTramite" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdFichaTramite" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[FichaTramite] ([FechaEnvio], [DNICliente], [IdCliente], [IdTipoFichaTramite], [Estado]) VALUES (@FechaEnvio, @DNICliente, @IdCliente, @IdTipoFichaTramite, @Estado)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@FechaEnvio" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="FechaEnvio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@DNICliente" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="DNICliente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdCliente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdCliente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdTipoFichaTramite" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdTipoFichaTramite" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Estado" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Estado" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IdFichaTramite, FechaEnvio, DNICliente, IdCliente, IdTipoFichaTramite, Estado FROM dbo.FichaTramite</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[FichaTramite] SET [FechaEnvio] = @FechaEnvio, [DNICliente] = @DNICliente, [IdCliente] = @IdCliente, [IdTipoFichaTramite] = @IdTipoFichaTramite, [Estado] = @Estado WHERE (([IdFichaTramite] = @Original_IdFichaTramite))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@FechaEnvio" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="FechaEnvio" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@DNICliente" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="DNICliente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdCliente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdCliente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdTipoFichaTramite" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdTipoFichaTramite" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Estado" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Estado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdFichaTramite" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdFichaTramite" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdFichaTramite" DataSetColumn="IdFichaTramite" />
              <Mapping SourceColumn="FechaEnvio" DataSetColumn="FechaEnvio" />
              <Mapping SourceColumn="DNICliente" DataSetColumn="DNICliente" />
              <Mapping SourceColumn="IdCliente" DataSetColumn="IdCliente" />
              <Mapping SourceColumn="IdTipoFichaTramite" DataSetColumn="IdTipoFichaTramite" />
              <Mapping SourceColumn="Estado" DataSetColumn="Estado" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FichaTramiteDocumentoTableAdapter" GeneratorDataComponentClassName="FichaTramiteDocumentoTableAdapter" Name="FichaTramiteDocumento" UserDataComponentName="FichaTramiteDocumentoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="conexion (Settings)" DbObjectName="SGTD.dbo.FichaTramiteDocumento" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[FichaTramiteDocumento] WHERE (([IdFichaTramiteDocumento] = @Original_IdFichaTramiteDocumento))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdFichaTramiteDocumento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdFichaTramiteDocumento" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[FichaTramiteDocumento] ([IdFichaTramite], [IdDocumento], [FechaCarga], [EstadoEntrega], [Adjunto], [Asunto], [IdArea], [Especificaciones], [Urgente]) VALUES (@IdFichaTramite, @IdDocumento, @FechaCarga, @EstadoEntrega, @Adjunto, @Asunto, @IdArea, @Especificaciones, @Urgente)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdFichaTramite" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdFichaTramite" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdDocumento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdDocumento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@FechaCarga" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="FechaCarga" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EstadoEntrega" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EstadoEntrega" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Adjunto" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Adjunto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Asunto" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Asunto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdArea" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdArea" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Especificaciones" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Especificaciones" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Urgente" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Urgente" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IdFichaTramiteDocumento, IdFichaTramite, IdDocumento, FechaCarga, EstadoEntrega, Adjunto, Asunto, IdArea, Especificaciones, Urgente FROM dbo.FichaTramiteDocumento</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[FichaTramiteDocumento] SET [IdFichaTramite] = @IdFichaTramite, [IdDocumento] = @IdDocumento, [FechaCarga] = @FechaCarga, [EstadoEntrega] = @EstadoEntrega, [Adjunto] = @Adjunto, [Asunto] = @Asunto, [IdArea] = @IdArea, [Especificaciones] = @Especificaciones, [Urgente] = @Urgente WHERE (([IdFichaTramiteDocumento] = @Original_IdFichaTramiteDocumento))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdFichaTramite" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdFichaTramite" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdDocumento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdDocumento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@FechaCarga" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="FechaCarga" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EstadoEntrega" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EstadoEntrega" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Adjunto" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Adjunto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Asunto" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Asunto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdArea" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdArea" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Especificaciones" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Especificaciones" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Urgente" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Urgente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdFichaTramiteDocumento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdFichaTramiteDocumento" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdFichaTramiteDocumento" DataSetColumn="IdFichaTramiteDocumento" />
              <Mapping SourceColumn="IdFichaTramite" DataSetColumn="IdFichaTramite" />
              <Mapping SourceColumn="IdDocumento" DataSetColumn="IdDocumento" />
              <Mapping SourceColumn="FechaCarga" DataSetColumn="FechaCarga" />
              <Mapping SourceColumn="EstadoEntrega" DataSetColumn="EstadoEntrega" />
              <Mapping SourceColumn="Adjunto" DataSetColumn="Adjunto" />
              <Mapping SourceColumn="Asunto" DataSetColumn="Asunto" />
              <Mapping SourceColumn="IdArea" DataSetColumn="IdArea" />
              <Mapping SourceColumn="Especificaciones" DataSetColumn="Especificaciones" />
              <Mapping SourceColumn="Urgente" DataSetColumn="Urgente" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TipoDocumentoTableAdapter" GeneratorDataComponentClassName="TipoDocumentoTableAdapter" Name="TipoDocumento" UserDataComponentName="TipoDocumentoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="conexion (Settings)" DbObjectName="SGTD.dbo.TipoDocumento" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[TipoDocumento] WHERE (([IdTipoDocumento] = @Original_IdTipoDocumento))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdTipoDocumento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdTipoDocumento" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[TipoDocumento] ([Nombre], [Estado]) VALUES (@Nombre, @Estado)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nombre" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Estado" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Estado" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IdTipoDocumento, Nombre, Estado FROM dbo.TipoDocumento</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[TipoDocumento] SET [Nombre] = @Nombre, [Estado] = @Estado WHERE (([IdTipoDocumento] = @Original_IdTipoDocumento))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nombre" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Estado" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Estado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdTipoDocumento" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdTipoDocumento" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdTipoDocumento" DataSetColumn="IdTipoDocumento" />
              <Mapping SourceColumn="Nombre" DataSetColumn="Nombre" />
              <Mapping SourceColumn="Estado" DataSetColumn="Estado" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TipoFichaTramiteTableAdapter" GeneratorDataComponentClassName="TipoFichaTramiteTableAdapter" Name="TipoFichaTramite" UserDataComponentName="TipoFichaTramiteTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="conexion (Settings)" DbObjectName="SGTD.dbo.TipoFichaTramite" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[TipoFichaTramite] WHERE (([IdTipoFichaTramite] = @Original_IdTipoFichaTramite))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdTipoFichaTramite" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdTipoFichaTramite" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[TipoFichaTramite] ([Nombre], [Estado]) VALUES (@Nombre, @Estado)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nombre" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Estado" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Estado" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IdTipoFichaTramite, Nombre, Estado FROM dbo.TipoFichaTramite</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[TipoFichaTramite] SET [Nombre] = @Nombre, [Estado] = @Estado WHERE (([IdTipoFichaTramite] = @Original_IdTipoFichaTramite))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nombre" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nombre" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Estado" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Estado" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdTipoFichaTramite" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdTipoFichaTramite" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdTipoFichaTramite" DataSetColumn="IdTipoFichaTramite" />
              <Mapping SourceColumn="Nombre" DataSetColumn="Nombre" />
              <Mapping SourceColumn="Estado" DataSetColumn="Estado" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FichaTDoc_reporte_PATableAdapter" GeneratorDataComponentClassName="FichaTDoc_reporte_PATableAdapter" Name="FichaTDoc_reporte_PA" UserDataComponentName="FichaTDoc_reporte_PATableAdapter">
            <MainSource>
              <DbSource ConnectionRef="conexion (Settings)" DbObjectName="SGTD.dbo.FichaTDoc_reporte_PA" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.FichaTDoc_reporte_PA</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idarea" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@fechaini" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@fechafin" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nchar" DbType="StringFixedLength" Direction="Input" ParameterName="@estado" Precision="0" ProviderType="NChar" Scale="0" Size="20" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@opc" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdFichaTramite" DataSetColumn="IdFichaTramite" />
              <Mapping SourceColumn="IdDocumento" DataSetColumn="IdDocumento" />
              <Mapping SourceColumn="fechacarga" DataSetColumn="fechacarga" />
              <Mapping SourceColumn="EstadoEntrega" DataSetColumn="EstadoEntrega" />
              <Mapping SourceColumn="Asunto" DataSetColumn="Asunto" />
              <Mapping SourceColumn="NombreArea" DataSetColumn="NombreArea" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="SGTDdsReporte1" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="SGTDdsReporte1" msprop:Generator_UserDSName="SGTDdsReporte1">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Area" msprop:Generator_TableClassName="AreaDataTable" msprop:Generator_TableVarName="tableArea" msprop:Generator_TablePropName="Area" msprop:Generator_RowDeletingName="AreaRowDeleting" msprop:Generator_UserTableName="Area" msprop:Generator_RowChangingName="AreaRowChanging" msprop:Generator_RowEvHandlerName="AreaRowChangeEventHandler" msprop:Generator_RowDeletedName="AreaRowDeleted" msprop:Generator_RowEvArgName="AreaRowChangeEvent" msprop:Generator_RowChangedName="AreaRowChanged" msprop:Generator_RowClassName="AreaRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IdArea" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIdArea" msprop:Generator_ColumnPropNameInRow="IdArea" msprop:Generator_ColumnPropNameInTable="IdAreaColumn" msprop:Generator_UserColumnName="IdArea" type="xs:int" />
              <xs:element name="NombreArea" msprop:Generator_ColumnVarNameInTable="columnNombreArea" msprop:Generator_ColumnPropNameInRow="NombreArea" msprop:Generator_ColumnPropNameInTable="NombreAreaColumn" msprop:Generator_UserColumnName="NombreArea">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IdJefe" msprop:Generator_ColumnVarNameInTable="columnIdJefe" msprop:Generator_ColumnPropNameInRow="IdJefe" msprop:Generator_ColumnPropNameInTable="IdJefeColumn" msprop:Generator_UserColumnName="IdJefe" type="xs:int" minOccurs="0" />
              <xs:element name="Estado" msprop:Generator_ColumnVarNameInTable="columnEstado" msprop:Generator_ColumnPropNameInRow="Estado" msprop:Generator_ColumnPropNameInTable="EstadoColumn" msprop:Generator_UserColumnName="Estado" type="xs:boolean" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Correo" msprop:Generator_TableClassName="CorreoDataTable" msprop:Generator_TableVarName="tableCorreo" msprop:Generator_TablePropName="Correo" msprop:Generator_RowDeletingName="CorreoRowDeleting" msprop:Generator_UserTableName="Correo" msprop:Generator_RowChangingName="CorreoRowChanging" msprop:Generator_RowEvHandlerName="CorreoRowChangeEventHandler" msprop:Generator_RowDeletedName="CorreoRowDeleted" msprop:Generator_RowEvArgName="CorreoRowChangeEvent" msprop:Generator_RowChangedName="CorreoRowChanged" msprop:Generator_RowClassName="CorreoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IdCorreo" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIdCorreo" msprop:Generator_ColumnPropNameInRow="IdCorreo" msprop:Generator_ColumnPropNameInTable="IdCorreoColumn" msprop:Generator_UserColumnName="IdCorreo" type="xs:int" />
              <xs:element name="Mensaje" msprop:Generator_ColumnVarNameInTable="columnMensaje" msprop:Generator_ColumnPropNameInRow="Mensaje" msprop:Generator_ColumnPropNameInTable="MensajeColumn" msprop:Generator_UserColumnName="Mensaje">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Asunto" msprop:Generator_ColumnVarNameInTable="columnAsunto" msprop:Generator_ColumnPropNameInRow="Asunto" msprop:Generator_ColumnPropNameInTable="AsuntoColumn" msprop:Generator_UserColumnName="Asunto">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Destinatario" msprop:Generator_ColumnVarNameInTable="columnDestinatario" msprop:Generator_ColumnPropNameInRow="Destinatario" msprop:Generator_ColumnPropNameInTable="DestinatarioColumn" msprop:Generator_UserColumnName="Destinatario" type="xs:int" />
              <xs:element name="Emisor" msprop:Generator_ColumnVarNameInTable="columnEmisor" msprop:Generator_ColumnPropNameInRow="Emisor" msprop:Generator_ColumnPropNameInTable="EmisorColumn" msprop:Generator_UserColumnName="Emisor" type="xs:int" />
              <xs:element name="Estado" msprop:Generator_ColumnVarNameInTable="columnEstado" msprop:Generator_ColumnPropNameInRow="Estado" msprop:Generator_ColumnPropNameInTable="EstadoColumn" msprop:Generator_UserColumnName="Estado">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IdFichaTramiteDocumento" msprop:Generator_ColumnVarNameInTable="columnIdFichaTramiteDocumento" msprop:Generator_ColumnPropNameInRow="IdFichaTramiteDocumento" msprop:Generator_ColumnPropNameInTable="IdFichaTramiteDocumentoColumn" msprop:Generator_UserColumnName="IdFichaTramiteDocumento" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Documento" msprop:Generator_TableClassName="DocumentoDataTable" msprop:Generator_TableVarName="tableDocumento" msprop:Generator_TablePropName="Documento" msprop:Generator_RowDeletingName="DocumentoRowDeleting" msprop:Generator_UserTableName="Documento" msprop:Generator_RowChangingName="DocumentoRowChanging" msprop:Generator_RowEvHandlerName="DocumentoRowChangeEventHandler" msprop:Generator_RowDeletedName="DocumentoRowDeleted" msprop:Generator_RowEvArgName="DocumentoRowChangeEvent" msprop:Generator_RowChangedName="DocumentoRowChanged" msprop:Generator_RowClassName="DocumentoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IdDocumento" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIdDocumento" msprop:Generator_ColumnPropNameInRow="IdDocumento" msprop:Generator_ColumnPropNameInTable="IdDocumentoColumn" msprop:Generator_UserColumnName="IdDocumento" type="xs:int" />
              <xs:element name="NroDocumento" msprop:Generator_ColumnVarNameInTable="columnNroDocumento" msprop:Generator_ColumnPropNameInRow="NroDocumento" msprop:Generator_ColumnPropNameInTable="NroDocumentoColumn" msprop:Generator_UserColumnName="NroDocumento" type="xs:int" />
              <xs:element name="Nombre" msprop:Generator_ColumnVarNameInTable="columnNombre" msprop:Generator_ColumnPropNameInRow="Nombre" msprop:Generator_ColumnPropNameInTable="NombreColumn" msprop:Generator_UserColumnName="Nombre">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IdTipoDocumento" msprop:Generator_ColumnVarNameInTable="columnIdTipoDocumento" msprop:Generator_ColumnPropNameInRow="IdTipoDocumento" msprop:Generator_ColumnPropNameInTable="IdTipoDocumentoColumn" msprop:Generator_UserColumnName="IdTipoDocumento" type="xs:int" />
              <xs:element name="IdTipoFichaTramite" msprop:Generator_ColumnVarNameInTable="columnIdTipoFichaTramite" msprop:Generator_ColumnPropNameInRow="IdTipoFichaTramite" msprop:Generator_ColumnPropNameInTable="IdTipoFichaTramiteColumn" msprop:Generator_UserColumnName="IdTipoFichaTramite" type="xs:int" />
              <xs:element name="Estado" msprop:Generator_ColumnVarNameInTable="columnEstado" msprop:Generator_ColumnPropNameInRow="Estado" msprop:Generator_ColumnPropNameInTable="EstadoColumn" msprop:Generator_UserColumnName="Estado" type="xs:boolean" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="FichaTramite" msprop:Generator_TableClassName="FichaTramiteDataTable" msprop:Generator_TableVarName="tableFichaTramite" msprop:Generator_TablePropName="FichaTramite" msprop:Generator_RowDeletingName="FichaTramiteRowDeleting" msprop:Generator_UserTableName="FichaTramite" msprop:Generator_RowChangingName="FichaTramiteRowChanging" msprop:Generator_RowEvHandlerName="FichaTramiteRowChangeEventHandler" msprop:Generator_RowDeletedName="FichaTramiteRowDeleted" msprop:Generator_RowEvArgName="FichaTramiteRowChangeEvent" msprop:Generator_RowChangedName="FichaTramiteRowChanged" msprop:Generator_RowClassName="FichaTramiteRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IdFichaTramite" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIdFichaTramite" msprop:Generator_ColumnPropNameInRow="IdFichaTramite" msprop:Generator_ColumnPropNameInTable="IdFichaTramiteColumn" msprop:Generator_UserColumnName="IdFichaTramite" type="xs:int" />
              <xs:element name="FechaEnvio" msprop:Generator_ColumnVarNameInTable="columnFechaEnvio" msprop:Generator_ColumnPropNameInRow="FechaEnvio" msprop:Generator_ColumnPropNameInTable="FechaEnvioColumn" msprop:Generator_UserColumnName="FechaEnvio" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DNICliente" msprop:Generator_ColumnVarNameInTable="columnDNICliente" msprop:Generator_ColumnPropNameInRow="DNICliente" msprop:Generator_ColumnPropNameInTable="DNIClienteColumn" msprop:Generator_UserColumnName="DNICliente" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="8" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IdCliente" msprop:Generator_ColumnVarNameInTable="columnIdCliente" msprop:Generator_ColumnPropNameInRow="IdCliente" msprop:Generator_ColumnPropNameInTable="IdClienteColumn" msprop:Generator_UserColumnName="IdCliente" type="xs:int" minOccurs="0" />
              <xs:element name="IdTipoFichaTramite" msprop:Generator_ColumnVarNameInTable="columnIdTipoFichaTramite" msprop:Generator_ColumnPropNameInRow="IdTipoFichaTramite" msprop:Generator_ColumnPropNameInTable="IdTipoFichaTramiteColumn" msprop:Generator_UserColumnName="IdTipoFichaTramite" type="xs:int" minOccurs="0" />
              <xs:element name="Estado" msprop:Generator_ColumnVarNameInTable="columnEstado" msprop:Generator_ColumnPropNameInRow="Estado" msprop:Generator_ColumnPropNameInTable="EstadoColumn" msprop:Generator_UserColumnName="Estado" type="xs:boolean" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="FichaTramiteDocumento" msprop:Generator_TableClassName="FichaTramiteDocumentoDataTable" msprop:Generator_TableVarName="tableFichaTramiteDocumento" msprop:Generator_TablePropName="FichaTramiteDocumento" msprop:Generator_RowDeletingName="FichaTramiteDocumentoRowDeleting" msprop:Generator_UserTableName="FichaTramiteDocumento" msprop:Generator_RowChangingName="FichaTramiteDocumentoRowChanging" msprop:Generator_RowEvHandlerName="FichaTramiteDocumentoRowChangeEventHandler" msprop:Generator_RowDeletedName="FichaTramiteDocumentoRowDeleted" msprop:Generator_RowEvArgName="FichaTramiteDocumentoRowChangeEvent" msprop:Generator_RowChangedName="FichaTramiteDocumentoRowChanged" msprop:Generator_RowClassName="FichaTramiteDocumentoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IdFichaTramiteDocumento" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIdFichaTramiteDocumento" msprop:Generator_ColumnPropNameInRow="IdFichaTramiteDocumento" msprop:Generator_ColumnPropNameInTable="IdFichaTramiteDocumentoColumn" msprop:Generator_UserColumnName="IdFichaTramiteDocumento" type="xs:int" />
              <xs:element name="IdFichaTramite" msprop:Generator_ColumnVarNameInTable="columnIdFichaTramite" msprop:Generator_ColumnPropNameInRow="IdFichaTramite" msprop:Generator_ColumnPropNameInTable="IdFichaTramiteColumn" msprop:Generator_UserColumnName="IdFichaTramite" type="xs:int" minOccurs="0" />
              <xs:element name="IdDocumento" msprop:Generator_ColumnVarNameInTable="columnIdDocumento" msprop:Generator_ColumnPropNameInRow="IdDocumento" msprop:Generator_ColumnPropNameInTable="IdDocumentoColumn" msprop:Generator_UserColumnName="IdDocumento" type="xs:int" minOccurs="0" />
              <xs:element name="FechaCarga" msprop:Generator_ColumnVarNameInTable="columnFechaCarga" msprop:Generator_ColumnPropNameInRow="FechaCarga" msprop:Generator_ColumnPropNameInTable="FechaCargaColumn" msprop:Generator_UserColumnName="FechaCarga" type="xs:dateTime" minOccurs="0" />
              <xs:element name="EstadoEntrega" msprop:Generator_ColumnVarNameInTable="columnEstadoEntrega" msprop:Generator_ColumnPropNameInRow="EstadoEntrega" msprop:Generator_ColumnPropNameInTable="EstadoEntregaColumn" msprop:Generator_UserColumnName="EstadoEntrega" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Adjunto" msprop:Generator_ColumnVarNameInTable="columnAdjunto" msprop:Generator_ColumnPropNameInRow="Adjunto" msprop:Generator_ColumnPropNameInTable="AdjuntoColumn" msprop:Generator_UserColumnName="Adjunto" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="300" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Asunto" msprop:Generator_ColumnVarNameInTable="columnAsunto" msprop:Generator_ColumnPropNameInRow="Asunto" msprop:Generator_ColumnPropNameInTable="AsuntoColumn" msprop:Generator_UserColumnName="Asunto" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IdArea" msprop:Generator_ColumnVarNameInTable="columnIdArea" msprop:Generator_ColumnPropNameInRow="IdArea" msprop:Generator_ColumnPropNameInTable="IdAreaColumn" msprop:Generator_UserColumnName="IdArea" type="xs:int" minOccurs="0" />
              <xs:element name="Especificaciones" msprop:Generator_ColumnVarNameInTable="columnEspecificaciones" msprop:Generator_ColumnPropNameInRow="Especificaciones" msprop:Generator_ColumnPropNameInTable="EspecificacionesColumn" msprop:Generator_UserColumnName="Especificaciones" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="300" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Urgente" msprop:Generator_ColumnVarNameInTable="columnUrgente" msprop:Generator_ColumnPropNameInRow="Urgente" msprop:Generator_ColumnPropNameInTable="UrgenteColumn" msprop:Generator_UserColumnName="Urgente" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TipoDocumento" msprop:Generator_TableClassName="TipoDocumentoDataTable" msprop:Generator_TableVarName="tableTipoDocumento" msprop:Generator_TablePropName="TipoDocumento" msprop:Generator_RowDeletingName="TipoDocumentoRowDeleting" msprop:Generator_UserTableName="TipoDocumento" msprop:Generator_RowChangingName="TipoDocumentoRowChanging" msprop:Generator_RowEvHandlerName="TipoDocumentoRowChangeEventHandler" msprop:Generator_RowDeletedName="TipoDocumentoRowDeleted" msprop:Generator_RowEvArgName="TipoDocumentoRowChangeEvent" msprop:Generator_RowChangedName="TipoDocumentoRowChanged" msprop:Generator_RowClassName="TipoDocumentoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IdTipoDocumento" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIdTipoDocumento" msprop:Generator_ColumnPropNameInRow="IdTipoDocumento" msprop:Generator_ColumnPropNameInTable="IdTipoDocumentoColumn" msprop:Generator_UserColumnName="IdTipoDocumento" type="xs:int" />
              <xs:element name="Nombre" msprop:Generator_ColumnVarNameInTable="columnNombre" msprop:Generator_ColumnPropNameInRow="Nombre" msprop:Generator_ColumnPropNameInTable="NombreColumn" msprop:Generator_UserColumnName="Nombre">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Estado" msprop:Generator_ColumnVarNameInTable="columnEstado" msprop:Generator_ColumnPropNameInRow="Estado" msprop:Generator_ColumnPropNameInTable="EstadoColumn" msprop:Generator_UserColumnName="Estado" type="xs:boolean" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TipoFichaTramite" msprop:Generator_TableClassName="TipoFichaTramiteDataTable" msprop:Generator_TableVarName="tableTipoFichaTramite" msprop:Generator_TablePropName="TipoFichaTramite" msprop:Generator_RowDeletingName="TipoFichaTramiteRowDeleting" msprop:Generator_UserTableName="TipoFichaTramite" msprop:Generator_RowChangingName="TipoFichaTramiteRowChanging" msprop:Generator_RowEvHandlerName="TipoFichaTramiteRowChangeEventHandler" msprop:Generator_RowDeletedName="TipoFichaTramiteRowDeleted" msprop:Generator_RowEvArgName="TipoFichaTramiteRowChangeEvent" msprop:Generator_RowChangedName="TipoFichaTramiteRowChanged" msprop:Generator_RowClassName="TipoFichaTramiteRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IdTipoFichaTramite" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIdTipoFichaTramite" msprop:Generator_ColumnPropNameInRow="IdTipoFichaTramite" msprop:Generator_ColumnPropNameInTable="IdTipoFichaTramiteColumn" msprop:Generator_UserColumnName="IdTipoFichaTramite" type="xs:int" />
              <xs:element name="Nombre" msprop:Generator_ColumnVarNameInTable="columnNombre" msprop:Generator_ColumnPropNameInRow="Nombre" msprop:Generator_ColumnPropNameInTable="NombreColumn" msprop:Generator_UserColumnName="Nombre">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Estado" msprop:Generator_ColumnVarNameInTable="columnEstado" msprop:Generator_ColumnPropNameInRow="Estado" msprop:Generator_ColumnPropNameInTable="EstadoColumn" msprop:Generator_UserColumnName="Estado" type="xs:boolean" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="FichaTDoc_reporte_PA" msprop:Generator_TableClassName="FichaTDoc_reporte_PADataTable" msprop:Generator_TableVarName="tableFichaTDoc_reporte_PA" msprop:Generator_TablePropName="FichaTDoc_reporte_PA" msprop:Generator_RowDeletingName="FichaTDoc_reporte_PARowDeleting" msprop:Generator_UserTableName="FichaTDoc_reporte_PA" msprop:Generator_RowChangingName="FichaTDoc_reporte_PARowChanging" msprop:Generator_RowEvHandlerName="FichaTDoc_reporte_PARowChangeEventHandler" msprop:Generator_RowDeletedName="FichaTDoc_reporte_PARowDeleted" msprop:Generator_RowEvArgName="FichaTDoc_reporte_PARowChangeEvent" msprop:Generator_RowChangedName="FichaTDoc_reporte_PARowChanged" msprop:Generator_RowClassName="FichaTDoc_reporte_PARow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IdFichaTramite" msprop:Generator_ColumnVarNameInTable="columnIdFichaTramite" msprop:Generator_ColumnPropNameInRow="IdFichaTramite" msprop:Generator_ColumnPropNameInTable="IdFichaTramiteColumn" msprop:Generator_UserColumnName="IdFichaTramite" type="xs:int" minOccurs="0" />
              <xs:element name="IdDocumento" msprop:Generator_ColumnVarNameInTable="columnIdDocumento" msprop:Generator_ColumnPropNameInRow="IdDocumento" msprop:Generator_ColumnPropNameInTable="IdDocumentoColumn" msprop:Generator_UserColumnName="IdDocumento" type="xs:int" minOccurs="0" />
              <xs:element name="fechacarga" msprop:Generator_ColumnVarNameInTable="columnfechacarga" msprop:Generator_ColumnPropNameInRow="fechacarga" msprop:Generator_ColumnPropNameInTable="fechacargaColumn" msprop:Generator_UserColumnName="fechacarga" type="xs:dateTime" minOccurs="0" />
              <xs:element name="EstadoEntrega" msprop:Generator_ColumnVarNameInTable="columnEstadoEntrega" msprop:Generator_ColumnPropNameInRow="EstadoEntrega" msprop:Generator_ColumnPropNameInTable="EstadoEntregaColumn" msprop:Generator_UserColumnName="EstadoEntrega" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Asunto" msprop:Generator_ColumnVarNameInTable="columnAsunto" msprop:Generator_ColumnPropNameInRow="Asunto" msprop:Generator_ColumnPropNameInTable="AsuntoColumn" msprop:Generator_UserColumnName="Asunto" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NombreArea" msprop:Generator_ColumnVarNameInTable="columnNombreArea" msprop:Generator_ColumnPropNameInRow="NombreArea" msprop:Generator_ColumnPropNameInTable="NombreAreaColumn" msprop:Generator_UserColumnName="NombreArea">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Area" />
      <xs:field xpath="mstns:IdArea" />
    </xs:unique>
    <xs:unique name="Correo_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Correo" />
      <xs:field xpath="mstns:IdCorreo" />
    </xs:unique>
    <xs:unique name="Documento_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Documento" />
      <xs:field xpath="mstns:IdDocumento" />
    </xs:unique>
    <xs:unique name="FichaTramite_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:FichaTramite" />
      <xs:field xpath="mstns:IdFichaTramite" />
    </xs:unique>
    <xs:unique name="FichaTramiteDocumento_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:FichaTramiteDocumento" />
      <xs:field xpath="mstns:IdFichaTramiteDocumento" />
    </xs:unique>
    <xs:unique name="TipoDocumento_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TipoDocumento" />
      <xs:field xpath="mstns:IdTipoDocumento" />
    </xs:unique>
    <xs:unique name="TipoFichaTramite_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TipoFichaTramite" />
      <xs:field xpath="mstns:IdTipoFichaTramite" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_Correo_FichaTramiteDocumento" msdata:parent="FichaTramiteDocumento" msdata:child="Correo" msdata:parentkey="IdFichaTramiteDocumento" msdata:childkey="IdFichaTramiteDocumento" msprop:Generator_UserChildTable="Correo" msprop:Generator_ChildPropName="GetCorreoRows" msprop:Generator_ParentPropName="FichaTramiteDocumentoRow" msprop:Generator_UserRelationName="FK_Correo_FichaTramiteDocumento" msprop:Generator_RelationVarName="relationFK_Correo_FichaTramiteDocumento" msprop:Generator_UserParentTable="FichaTramiteDocumento" />
      <msdata:Relationship name="FK_Documento_TipoDocumento" msdata:parent="TipoDocumento" msdata:child="Documento" msdata:parentkey="IdTipoDocumento" msdata:childkey="IdTipoDocumento" msprop:Generator_UserChildTable="Documento" msprop:Generator_ChildPropName="GetDocumentoRows" msprop:Generator_ParentPropName="TipoDocumentoRow" msprop:Generator_UserRelationName="FK_Documento_TipoDocumento" msprop:Generator_RelationVarName="relationFK_Documento_TipoDocumento" msprop:Generator_UserParentTable="TipoDocumento" />
      <msdata:Relationship name="FK_FichaTramite_TipoFichaTramite" msdata:parent="TipoFichaTramite" msdata:child="FichaTramite" msdata:parentkey="IdTipoFichaTramite" msdata:childkey="IdTipoFichaTramite" msprop:Generator_UserChildTable="FichaTramite" msprop:Generator_ChildPropName="GetFichaTramiteRows" msprop:Generator_ParentPropName="TipoFichaTramiteRow" msprop:Generator_UserRelationName="FK_FichaTramite_TipoFichaTramite" msprop:Generator_RelationVarName="relationFK_FichaTramite_TipoFichaTramite" msprop:Generator_UserParentTable="TipoFichaTramite" />
      <msdata:Relationship name="FK_FichaTramiteDocumento_Area" msdata:parent="Area" msdata:child="FichaTramiteDocumento" msdata:parentkey="IdArea" msdata:childkey="IdArea" msprop:Generator_UserChildTable="FichaTramiteDocumento" msprop:Generator_ChildPropName="GetFichaTramiteDocumentoRows" msprop:Generator_ParentPropName="AreaRow" msprop:Generator_UserRelationName="FK_FichaTramiteDocumento_Area" msprop:Generator_RelationVarName="relationFK_FichaTramiteDocumento_Area" msprop:Generator_UserParentTable="Area" />
      <msdata:Relationship name="FK_FichaTramiteDocumento_Documento" msdata:parent="Documento" msdata:child="FichaTramiteDocumento" msdata:parentkey="IdDocumento" msdata:childkey="IdDocumento" msprop:Generator_UserChildTable="FichaTramiteDocumento" msprop:Generator_ChildPropName="GetFichaTramiteDocumentoRows" msprop:Generator_ParentPropName="DocumentoRow" msprop:Generator_UserRelationName="FK_FichaTramiteDocumento_Documento" msprop:Generator_RelationVarName="relationFK_FichaTramiteDocumento_Documento" msprop:Generator_UserParentTable="Documento" />
      <msdata:Relationship name="FK_FichaTramiteDocumento_FichaTramite" msdata:parent="FichaTramite" msdata:child="FichaTramiteDocumento" msdata:parentkey="IdFichaTramite" msdata:childkey="IdFichaTramite" msprop:Generator_UserChildTable="FichaTramiteDocumento" msprop:Generator_ChildPropName="GetFichaTramiteDocumentoRows" msprop:Generator_ParentPropName="FichaTramiteRow" msprop:Generator_UserRelationName="FK_FichaTramiteDocumento_FichaTramite" msprop:Generator_RelationVarName="relationFK_FichaTramiteDocumento_FichaTramite" msprop:Generator_UserParentTable="FichaTramite" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>